alter table jms_dm.dm_netmng_month_order_sign_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_netmng_month_order_sign_summary_dt;
create external table jms_dm.dm_netmng_month_order_sign_summary_dt
(
    month_first_day string comment '月的第一天',
    mon_num         int comment '下单量',
    mon_sign_num    int comment '下单量中签收的单',
    date_time       string comment 't-1天'
) comment '签收率'
    partitioned by (dt string comment 't-1')
    stored as parquet
    location '/dw/hive/jms_dm.db/external/dm_netmng_month_order_sign_summary_dt'
